-
Re: Does a workflow in a Data Shuttle have the ability to pull an updated report in a SharePoint Folder?
Data Shuttle looks for a file by name in OneDrive. What I would do is use Power Automate to stage the file for Smartsheet to pick up, and then either delete it or overwrite it with the new file the n…1 · -
Re: Count Past Due Task and Exclude Status that is Complete
You don't the second AND Edit to add: if that does not work, I would create a checkbox column that tests your AND statement, and then use that column as the second COUNTIFS criteria.1 · -
Re: How to transform a Multi-select dropdown into multiple rows
You have encountered a limitation of Smartsheet, and I wish there was a way to make this happen. You could create a sheet that has a row for each possible selection for each person, and then filter t…2 · -
Re: Adding Names from Sheet 1 to Sheet 2 with Counter update and handling duplicates
I did this with two sheets called Sheet1 and Sheet2. Sheet1 has a column called NAMES, and it has your names in it. In Sheet2: Create a column called ROWID. This column should be an incrementing numb…1 · -
Re: Alert/Notification when line item hasn't been added
You can do this with two formulas: Max column: =IF(MAX(COLLECT([Update Date]:[Update Date], Person:Person, Person@row)) = [Update Date]@row, MAX(COLLECT([Update Date]:[Update Date], Person:Person, Pe…1 ·